It just depends on where the community gets its water from. My county has a huge man-made lake that is fed by spring-fed rivers. I think our water is fine and drink it all the time. My parents (same county) have a 450-foot-deep well that goes straight into the aquifer. They have amazing water. However, if you drill a shallow well (30-40 feet for irrigation only), the water has the sulphur smell to it.
I don't know where Orlando and Tampa get their water, but I know that when my brother lived in Orlando and my sister lived in Tampa, I could hardly stand to take a shower, the sulphur smell was so overwhelming. We typically bring bottled water along to WDW and do not drink the tap water there unless it's filtered.