North west cities in top 10 for hotel investment