I'd say Glasgow is the best and Manchester is the worst. I don't mind the lime water you get in the South that much, it's ok to drink with but it makes your kettles really gross, no offence.

Loch Katrine Glasgow water makes my hair all soft and repairs all the damage done by septic Manchester water.