Both South and West Yorkshire are named among the top five emerging hotspots for luxury living in the UK, in a new survey.