A Scottish city is set to ‘reclaim its place’ on the whisky map as planning permission has been granted for a new whisky distillery on an historic site.