Enjoy fine views, eye-catching art and a wee dram in Scotland’s biggest city