John Smith, First City Architect to Aberdeen