Put a spotlight at the level of the water, and make it point to the ceiling. Increase the FOV and radius, so the light touches all the room. Then, add a gobo called: gobo_water_01.dds.
Then, change the animation mode to "Loop" and put the frame time to 0.05 or 0.1.