If you have cast Iron Pipes in your house to deliver the water to your taps, or copper, you can get DOS problems. I used to use rain water, but moved house and the new one has Cast Iron Guttering, made in 1870 and suitable flakey, so I don't risk it. The mains supply in my house is good old lead (also made in 1870, so hopefully fully limescaled up by now), the rest is a mix of PVC and Copper. So far no issues. Our water here is high in calcium and copper, but low in iron and other metals, so it's OK for soap, by the looks of it. Other people in London get DOS with tap water. If that is due to cast iron piping in their area (some councils haven't updated their water pipes since the Romans provided them), or due to a different mineral mix in the water, I wouldn't know.
Fouride - hate the stuff in water. It's not exactly brilliant for us to drink all the time and cook in it, if you keep tropical fish you wont be able to use the tap water and if people would clean their teeth, they wouldn't get cavities....