Waveworld and Colorama. This combination is calble of simulating the surface and the interaction with some edges if you carefully build the alpha source for Waveworld. You can augment the illusion with Foam.

Fionding tutorials for Foam is next to impossible but Waveworld is explored by many.

I second what Andrew said. Shooting it yourself is much better and more fun!

If you absolutely need to do it digitally (why?) and photorealistically, you could do it with a liquids simulation in your 3d package (RealFlow, Blender's built in simulator, Maya's built in simulator, DPIT Effex for Cinema 4D). I don't know of a perfect way with AE.