Then invest in the syndication leveraging their knowledge.   

I will be looking to hire someone to run this business for me and they will be able to live in the house as part of their compensation.My goal is to renovate the rooms and cabins and expand by adding more year-round cabins designed for longer stays. 

I do not believe the economy is as rosy as it appears, so the rates can't stay the same and trend up/down a little.

I want to avoid "shiny object syndrome" so I am trying to widen our reach while also staying in the lane of value add that we are comfortable in and have been successful in. 

He is a wealth of knowledge and experience.

You have come to to the right place to soak up knowledge and resources.

It needs to be in an area with business travel so it stays booked.

Can you build an ADU on your current property, then rent it out and just stay in your current house? 

Pushing back will require a skilled attorney with knowledge of HOA law.

Always recommend checking out Furnished Finder Traveler search ( https://www.furnishedfinder.com/housing/New-York/New-York) and Airbnb/VRBO for 30+ days stays to get an idea of what's currently out there.