There's also a way to create rain (and snow) in Photoshop, as postwork. As a side note: on 3D world issue 37 (Gollum on the cover) there's a tutorial on creating rain-hit water in 3D Studio. Something similar to what pidjy used for the water surface up above.

-- erlik