That’s a solid idea, and yes it can absolutely work as a simple, low-maintenance fountain if you design it with consistent water flow and filtration in mind.
The key is making sure your water source and pump are balanced. Most DIY fountain setups run into trouble when the pump is either too strong (causing splash-out and water loss) or too weak (resulting in poor circulation). If you’re using a recycled container or gravity-fed system, aim for a steady, gentle flow rather than trying to push a dramatic spray. It’ll look better and require less upkeep.
One thing that often gets overlooked is debris management. Even a small fountain will clog quickly if leaves, algae, or sediment get into the system. A simple pre-filter (like a mesh screen over the intake) goes a long way. If you're pulling from a pond, placing the pump slightly elevated off the bottom helps avoid sucking in sludge.
For example, I’ve seen setups where people used a basic submersible pump feeding a vertical pipe or decorative spillway, and the difference-maker wasn’t the design it was keeping the intake clean and matching the pump to the height of the fountain. Even modest systems can look great when they run consistently.
If you’re scaling this up for a larger pond, something like Midwest Pond Pond and Lake Fountains
https://midwestponds.com/collections/pond-fountains follows the same principles, just with more robust flow control and aeration benefits built in.
Takeaway: keep the flow simple, protect your pump from debris, and size everything to match your water source ou’ll get a much more reliable (and enjoyable) fountain.