This scrappy Scottish city is clawing its way back from decay, restoring its wealth of historic landmarks and repurposing them as glamorous restaurants, art galleries and hotels.