Douglas Lake is a top bass and crappie fishing destination so that is very cool.

But it seemed like a good tourist destination. 

This is not a far-fetched scenario as it happened in Maimi Beach, a popular tourism destination and promising short-term rental market.

Considering buying a small house to rent out for fishing destinations.

@Michael Aschenbrenner I think you're on the right path in terms of asset protection, but there are a lot of details/minor corrections(Mike S. mentioned some) that need to be addressed to get you to your final destination here.

The area has been gentrifying for some time now and is currently a very popular weekend getaway/vacation destination for many city dwellers from the metro nyc area and to me it seems a good investment as taxes are not high and home prices remain affordable.

We did a 1031 exchange into a condo in Destin, FL.

My biggest concerns right now is finding a decent property manager (I hate to give anyone control, but I have a full time job), finding an on call good handyman, and talking with investors about other positive ways to finance the deal other than a conventional loan.Indiana, Florida, Ohio, Lake homes, and most tourist destinations are all interest to us!

Resort destinations are always popular too - which rules out many towns in the USA. 

I'd say so long as you're in a good location I don't foresee this trend changing all that much b/c these cities are also destinations for things like work events (i.e. traveling nurses, traveling professors), tourists and industry events (i.e. conferences and trade shows).