I am doing some experiments with Maya Fluid Effects to get some nice water. Apparently thats not what its made for, but I'm confident I'll be able to find some work-arounds. This is a still of water pouring.

At this point I'd like to integrate physically accurate photons with mental ray, but apparently thats not going to be so easy either. Until then I'm pretty happy with this kind of result.