A Scottish location has been crowned the most culturally vibrant place to live in the UK by a new study ranking 30 destinations across the nation.