Watercolor is a great media to convey anything related to water, including rain. Here is a watercolor cityscape tutorial to paint a rainy cityscape.
Erica DeHart