I've made several brews over the last year using Glasgow water (Milngavie apparently) and on the whole, apart from my own mistakes, they've tasted pretty great! I did nothing with the water at all on most occasions. Looking at the water profile, it's practically distilled (even more so than Pilsen which is world famous for its water profile). What I've read, and what my experience seems to confirm, is that if your water tastes nice, it should be good to use.
The water in Glasgow is very pure with low levels of everything (although apparently chlorides can vary depending on time, but they seem low, and boiling removes this anyway). This doesn't mean it will be suited for every style though. I suppose
From memory:
Magnesium is good for yeast health, but I've never had a problem with yeast despite this. If you have out of date or stressed yeast, maybe it won't be ideal?
Carbonate levels when low increase acidity, while the opposite situation (low acidity) damages mash efficiency. I've read the advantage of high acidity/low ph is that it reduces tannins (which is desirable!). Carbonate levels are reduced by boiling anyway (and I generally pre-boil).
Sodium is basically undesirable I think, and there's basically none in any Glasgow water.
Chloride is also generally undesirable. Pre-boiling reduces this too.
Sulfates are important for certain styles, and if you're trying to clone certain beers (e.g. Burton). It brings out hoppiness, which I am not overly interested in, but sounds like it could be a problem if you're trying to brew NEIPAs or something. I am not, so can't comment.
Calcium is where the controversy might lie. I have experimented with raising the level from 5ppm (very low) to 100ppm+ (as is apparently desirable) on a couple of occasions, but I thought the taste just wasn't as good... But I'm glad I tested, as now I know. Mileage may vary. I use noble hops, which apparently go well with lower calcium water also.
The sulfate to chloride ratio is apparently important. It's roughly balanced in Glasgow's water.
The great thing about the mineral content of the local water is that if you're not happy, it's much easier to add minerals than it is to remove. I'm no expert on water or brewing, but I did look into it for a while and I was initially concerned about the low calcium and magnesium levels, but now I'm not. I actually prefer it how it is naturally!