Led Zeppelin's members can be split into two pairs in terms of their geographical origins, with Jimmy Page coming from Heston and John Paul Jones hailing from Sidcup, both in Greater London, whereas Robert Plant and John Bonham were both from the West Midlands, coming from the towns of West Bromwich and Redditch, respectively, both around Birmingham. This is reflected in Plant's support of Wolverhampton Wanderers F.C. as well as in the title of a song such as 'Black Country Woman' (For non-Brits, the Black Country is the urban area of the West Midlands to the west of Birmingham, which includes Wolverhampton, West Bromwich and Dudley).
The most important members of Pink Floyd - Syd Barrett, Roger Waters and David Gilmour - all came from in and around Cambridge, a city in the east of England best known for its university, one of the two most iconic in the UK along with Oxford. This explains the references to the extra-terrestrials in Let There Be More Light making their first contact with the human race at Mildenhall, a town near Cambridge, and Grantchester Meadows, associated with the eponymous village on the city's outskirts.
In the closest big city to where I live, Liverpool, there is one local band who tower above all others - The Beatles. Several Beatles songs can be traced to the city Penny Lane is a real street in Liverpool, and there is a statue of Eleanor Rigby in the city centre on Stanley Street. I am not the world's biggest Beatles fan but I know both of these locations well. Liverpool has a major rivalry with Manchester, which has also produced a lot of bands - The Smiths, The Stone Roses and Oasis for instance - although I'd say it came more to prominence in the 1980s, and doesn't tend to be associated with true classic rock.
Also of some musical significance is Newcastle Upon Tyne in the northeast. Sting comes from Wallsend and Mark Knopfler of Dire Straits, while not a Geordie by birth, moved from Glasgow to Newcastle while still a child and I believe is considered to be an 'honorary Geordie'. There are a few Dire Straits songs about life in and around Newcastle, especially on the debut album (Down To The Waterline and Southbound Again, specifically) but also on Tunnel Of Love and he later revisited the area in his solo career with songs such as Why Aye Man (a commonly used phrase amongst Geordies) and Fare Thee Well Northumberland. Having said this, a number of other Dire Straits songs are about London, including most of the second half of the debut album - Sultans Of Swing, Wild West End, etc. - as well as on Communique, which has Portobello Belle and Single Handed Sailor.