From what I have seen, most of the "water on skin" effects are done after render in an art program.  Some might do it in process with a 3d program, but I dont know of any offhand.  Skin textures will flatten on the figure, so would water painted ON the texture.