Smell is not an indication of danger.

Municipal water in Florida often has the smell of sulfur, due to the presence of sulfur -- and if I'm remembering correctly, a relative who works at the state equivalent of the EPA told me that it's common in coastal areas due to byproducts of bacteria in the water table. But it's completely harmless.

I can only speak for Florida, though.

Water in Orlando, FL is pretty terrible. It has a sulfuric and metallic taste and smell. It's perfectly safe to drink and bathe in, the smell doesn't stay on your skin, but it's gross. Do a quick google search for water quality in orlando, or sulfur or smelly water in Orlando. You'll find tons of results on travel forums from people visiting Disney ask if it's safe to drink the tap water at parks or in their hotels because of it.

I'm guessing that water in San Diego is the absolute stalest you can get in the US. The water San Diego receives is either piped over the mountains from Arizona or comes from way upstate...after Los Angeles has their pick.

There is no doubt that it is not good water. It is so high in salt content that the avocado growers complain about using it. If all you're doing is trying to stay alive then by all means, drink up.