Here's the opinion of several "experts":

http://www.newton.dep.anl.gov/askasci/wea00/wea00044.htm

Seems to me the bottom line is drink from the tap if you can but rainwater won't kill you.