Homemade water fountains make a statement in any yard, from the visual and sound of flowing water to creating a mini nature preserve for dragonflies and butterflies. All you need is a close basin for the water to collect in, a fountain pump (which you can order online), plastic tubing, and imagination.
To keep very simple, they have solar-powered water pumps that need no tubing. You can create a fountain out of a birdbath and the birds will love you for this.
Many fountain ideas are easy and cheap for a do-it-yourself project. Just make sure your basin (the structure that collects the water) is large enough where you do not have to refill it every day.