I created this 3D can in Cinema4D and added the water and the paint Splash in Photoshop. I painted the Splash by myself in Photoshop. 

I have Tutorials on my Youtube Channel (/ellypite) where I Show you how to make these paint-splashs in Photoshop, and another Tutorial where I Show you how to make the whole Picture.