There was a topic about rain on a window - which looked great as rain. would it be the same principal?
would it be possible to get that to work on a curved surface.?
The water material works best for horizontal surfaces.
For water running down a wall you can experiment with a video texture showing falling water. The upcoming support for videos with transparency may be useful here, because it will allow the falling water to be semi-transparent.