I used to get around one or two of the more deserted areas of Scotland, and I think your view of the Nimby response is more or less true wherever I found a wind farm being proposed. It's understandable, as it's one of the few installations that, by definition, has to be out in the open and unscreened. Plus, there has to be enough of them installed at any location to make them worthwhile.
This link's pretty good for info of local nature http://www.headpond.co.uk/Links.htm
I'd heard horror stories about the noise of these turbines, and had occasion to wander around a wind farm at the side of the A68 near Oxton http://tinyurl.com/6vkrp
Yes, there's an ROC post in the middle of it. All the turbines were operating, and the noise level was... non-existent at the roadside, and underneath the turbines was obviously noticable, but not enough to be noticed if conversing.
How many for Glasgow? Don't know the city's consumption now, but here's a throwaway number to work it out from "853 turbines currently produce 405 megawatts". Few years old now, so should take a few less with better tech.