A new distillery with 'breathtaking views' will open in the heart of Edinburgh next month.