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.