Faucet with
running water
3D Studio Max

This is an interior shot of a faucet with running water. I rendered it in Mental Ray and the water is a particle system in 3D Studio Max with a blur filter on it.