After watching Ellen try and get shots like this one, I can say with some confidence that it's not the gear that you use which makes this work, it's getting the @#$#@ bug to sit still long enough to snap the picture. Although admittedly having the correct macro lens definitely helps.

And I do wonder if the "rain" came out of a sprayer.