Hmmmm... I will probably be making one soon too. I am just about to finish an actual water fall, made from hypertufa boulders I assembled into a waterfall, but I also want to make a water fountain.

You can make all sorts of water fountains, the key thing is to hunt for the right molds. You can make a mold out of just about anything. I'm think about using those zip-lock containers.

As for the lily, it's very hard to reproduce with Hypertufa, given you start out with a muddy substance, but you can always use a couple of nice leaf castings.

I've reproduced the adobe-like look of terracotta by adding concrete dye (powder added to the mix). I buy mine from Olde World Stone, they have quite a selection and are very good with delivery. The only downside is the smallest size they have is 1/2 lbs., quite a bit for a water fountain.

Hope this helps