Personally, I'm not keen on flouridated water. I get enough flouride in my toothpaste and tea and don't much fancy them funky flourosis tainted teeth.

People often won't be ware if the level of flouride in their drinking water is high enough to ditch the flouride toothpaste until this happens. I do believe this is a cosmetic problem of flouridation though, and I don't subscribe to the cancer/David Icke crazy school of crazy control theory.
Afaik Aberdeen currently does not have flouridated water (not sure though), but also it has been seriously suggested and voted on more than once.
It's not something I care that much about though, I think this country has more pressing needs in the availability of dentists than worrying whether the water is naturally or unnaturally flouridated.