If you can use a projector, there are some pretty effective rain loops available. I can send you one if worse comes to worse. I also know there are such things as 'water' gobos', but have never had an opportunity to use one and if they have 'rain'.
Most effective rain lighting effect I've seen? Take about a dozen sharpies, fly your electric to within two feet of the sprinklers, and focus the lights accordingly.