If you want that "fountain feel" without the commercial lease, consider these more home-friendly options:

allow you to carbonate water and add flavors, though you'll be limited to one flavor at a time.

These units require a dedicated high-pressure water line and a professional drainage system to handle the "purge" cycles and spills.

However, if you are a business owner or have a commercial space, you can apply to house one through the Coca-Cola Freestyle Official Site. Why Can’t I Just Buy One for My Home?

You can buy a "Drop-In" or "Countertop" soda fountain system from retailers like Soda Dispenser Depot. These use standard 5-gallon "Bag-in-Box" (BIB) syrups. Smart Soda Makers: The SodaStream Terra Go to product viewer dialog for this item. Aarke Carbonator

You pay for the concentrated cartridges, CO2 tanks, and water filtration separately.