Here's an dynamic material simulating a rain streaming down a glass pane.

I think I managed to optimize it quite well for the quality at hand and it should be suitable for realtime use. If you need to have better performance, disable the landing droplets component - that'll up the framerate a lot, but it takes out some small detail.