I hope it's on, but what's the damage near the hotel or getting to and from the hotel and airport?

for a hotel and maybe $50 for a car....and a day or two of time to go ck your deals before you give someone $100,000 to invest in your behalf.    

You probably can’t put locks on individual bedrooms because that would turn your building into a hotel (unregulated, unregistered).The polite description of your plan is “folly in the extreme.”

Also, not sure if we need to by BPCON tickets for the kids for the hotel stay or not?

There is also a hotel/liquor store/restaurant for sale that I would like to buy.

UPDATE: The Hotel Occupancy Tax (HOT) compliance timeline has been moved to now start on February 1, 2025 (this was previously set to start in October)Any short term rental advertised through a platform remitting the hotel occupancy tax to the State of Texas (such as Airbnb or VRBO) will begin paying the San Antonio HOT directly to the city monthly through the platforms.

It’s like the BS facility fee, or resort charge, hotels use.

.-- If you're the lessee (and not the deed holder / owner): COH will require written consent by the owner to the use of their property as a        STR and to accept liability for taxes if the STR operator does not adequately remit Hotel Occupancy Taxes (HOT) as per local                         regulations. laws—a responsibility most owners will be reluctant to accept.-- Expect a grace period of two months once the new regulations are enacted into law.

You also have to consider county or local taxes (my main area has a 7% hotel tax for STRs on top of my 6% state).BiggerPockets has a STR/Airbnb calculator that may help bring them some clarity on the numbers! 

While it's a great spot with a ton of tourism unfortunately, it seems the hotels view STR's as competition and have helped to encourage the strict regulations.