Great page for DIY fountains. http://www.sunset.com/garden/backyard-projects/great-ideas-fountains-00400000045254/page35.html Gardens Ideas, Minis Gardens, Gardens Fountain, Front Yard, Gardens Water Features, Fountain Ideas, Small Gardens, Small Spaces, Flowerpot
Also on these boards
Free DIY Fountain Project - The soft splash of a fountain brings life and motion to the backyard. It attracts more birds than still water alone, and its soothing sound track transforms your space into a peaceful retreat.
Raised beds, collecting rainwater as well. - perhaps tiered beds can have a French drain at the end that catches excess water run off from the rain. It would be a larger area to collect rain water and would only be extra If the other plants were all watered.