Llombardo & Blanketback,
Here's some ideas for you.
Solar panels/fountain pumps are getting better and less expensive.
Solar Powered Water Fountain Pumps, Panels & Kits
This is a simple little fountain we got at homedepot several years ago. At night a solar light shines on it to highlight it's really pretty. (eta: the fountain itself is not solar btw, but it's close enough to an outdoor outlet that we use an outdoor rated extension cord)
I thought I had some pics of the pond and small waterfall we have from last summer but couldn't find any. Right now we're having a late spring for our area and it's still under cover/hibernation.
I'll try to find more pics.