You could definitely do this in Photoshop. If you can find lots of liquid splashes and water droplets, maybe from a stock site or even just high res google images, stitch them together, reshape them, reposition them and recolour. I have done this many times for splash effects, and the results are usually good.
Although I agree with the other comments about 3d max if you need more control over things like lighting, camera angles etc.