Reply to "How to make a small pond look like real water?"

I have used WS Realistic Water and then lightly brushed where needed with mod podge to form ripples.

You can paint the bottom surface to get the "look" you want, but you can also tint the Realistic Water to whatever color you're after.