Splash effect...
Well, you can paint it by hand (Wacom Tablet, meaning), or you can actually photograph a splash an insert it into the picture with different modes to be able t see through it, as well as shading and lighting.

Post a pic and let's see what we can come up with.
-Lew ;-)