Less interested in cash flow (but not NEGATIVE cashflow), more interested in location and having visitors/tenants pay down the mortgage.

If you are investing in a syndication as a passive investment, that would be very suitable, but if you intend to participate in the day-to-day on the project, you might want to reconsider.  

Make a website and organize an influx of visitors (SEO + Facebook Ads, PPC,...).

@Marci SteinSo which towns are better with rentals that is not disturbed by the summer visitors?

Before the advent of Airbnb, Scottsdale was a popular vacation destination for winter visitors who booked a minimum of 30 days.

Is it also suitable for big business with lots of units even billion dollar businesses?

What makes one market more suitable for BRRRR investing than another? 

Limited lodging shall only be permitted when arranged through a booking agent as defined in § 19-2401.Limited Lodging, Short Term.The accommodation of visitors conducted in a dwelling unit, the primary use of which is for household living, and where the total accommodations of visitors provided is for fewer than ninety-one (91) days per year but where the provision of lodging to any particular visitor is for no more than thirty (30) consecutive days.

If they are big guys, dump a lot, or use a lot of toilet paper, then make sure you have a toilet that flushes well and can handle the load.Show everyone who lives in the townhome (and regular visitors) the water turnoff that is behind to toilet and the water turnoffs that are under the sinks, in the laundry, etc.

Buyers, expense, time, developer suitability, city requirements.