You could use the PaintFX brush called Rain .. it looks great, but does not show up in reflections etc. since its a post effect. (Rendered after your actual image is rendered, and composited on to the image automatically by Maya)

Mike : You are BAD !!! LOL