Check out University Football Rentals at https://universityfootballrentals.com/. The locals leave town during the game so that you have a place to stay. You get to stay in a nice full home instead of a crappy hotel and they get paid for their weekend vacation. Perfect solution! This helps out both sides and also helps alleviate the pressures of short-term population explosion!
You could make some money or you could save some money. It's up to you.