Well I grew up on LA tap water and love it. Everyone that visits me and my family have no problem drinking it either (in the San Fernando Valley anyway).
The local tv news stations have done tests in the past to see if people could tell which was which (LA tap water, bottled water, tap water from other cities) and the LA water always fared well.
So dont be scared - drink up!!!