We’ve shared several posts on fountains like these homemade fountains just for inspiration, and these disappearing fountains. If you really want to, you can make a fountain out of just about anything.
A fountain is made from 3 things: water, a pump and something the water runs over.
Here is a tutorial on making a fountain using large stones found on-site but pavers, metals, or pottery can work. Check out the tutorial at the link below which includes images explaining the steps.
Making A Fountain From Concrete