Script-Fu -> Effects - Reflection
This is an adjustable script,
it generates a reflection in the foreground of the original image.
This is a play off an old script by Otavio Correa Cordeiro, edited by David Cummins and (yours truly) Paul Sherman...
See effects_water-reflection.html for a more close-up, watery, wavy version :-)