My favorite "rain" song with the classic first opening:
"Yesterday's newspapers forecast no rain for today
Yesterday's news was old news, the skies are all grey".
The song is Angeline by Mickey Newbury. (I believe he originally recorded it on an lp called "Looks Like Rain" on Mercury.)