A basic explanation of how water towers work. Having designed a few of these in my career the video is very accurate.
As an engineer we always advocate for simple resilient solutions. The elevated storage tank is by far the most effective way to provide water with low maintenance and high operational time.
Using pumps are costly and need replacement sooner than a water storage tank. In theory using a pump that adjusts the pressure based on usage sounds sustainable but the power and O&M will make it a nuisance.
For example. Something simple as “dirty power” from the utility company can knock out the variable frequency drive (VFD) which speeds up or slows down the pump impeller which increases the flow of water on demand. With the VFD out homeowners will call and complain about a lack of water pressure then you to call the VFD service team to have technicians come out and reprogram the VFD software logic to get it up and running again. If they can. Sometime the VFD is fried and needs to be replaced. Water access can be down for days or weeks to get this pump back up and running.
So stackers I say all this to reinforce the idea that elevated water storage tanks that rely on gravity to deliver water to homes is the best solution if it’s feasible.