In the heyday of North Sea oil, 'Granite City' Aberdeen boasted Britain's biggest concentration of millionaires - yet the former boom town has suffered a stark decline.