You can get a good solar fountain for under $100. The water will flow when the sky is sunny and cut back when it’s cloudy. You’ll be aware of how much sunshine you are receiving at any given time.
You can build a large solar fountain for a little bit more if you do most of the labor yourself and use natural landscaping elements, like indigenous rocks. You can build a really big fountain, and the only cost you’ll incur is for the solar pump.
You can build a solar fountain with a large upper reservoir so you can even out the fluctuations in water flow when the sun changes. The reservoir also allows you to save the water for use later, like when you’re dining nearby.
You can locate a solar fountain anywhere, as long as you put the PV panel in sunlight.