You may also opt to use brushes like ones for Photoshop.  I personally prefer the postwork approach as it is faster than having to render it.  Plus, it gives me more control over the wave materials.  Check out the 2d area here at Rendo and look under brushes.  There are lots for creating water effects.