Cary is one five cities and regions across the country have built a visitor following through sports