This Old House's web site offers a simple tutorial for turning any old thing into a fountain. Figure a $100 to $200 investment, but it can be done for a lot less if you repurpose something you already have, such as a fabulous urn or an old ornament. Just about anything...or any gathering of things, really!
The plan can be adjusted to include a submersible solar pump, for the energy-conscious. Here's a good one, for under $20, that comes with an array of nozzle heads.
Speaking of fabulous urns, consider this plan for turning one into a fountain. Check out our site, Look East: traders in asian style for a selection of exceptional, handmade Southeast Asian water jars, well-suited to this project. Some are one-of-a kind. We sell to the trade, so contact us if you have interest and we'll direct you to a local retailer or sell directly if one is not nearby.