Lua slams. Alluvial is way out on the north edge of Ames, but it's excellent beer in a unique setting (on the edge of 40 acres of restored native prairie). I'd either hit it before checking into your Airbnb, or take an Uber out there.
You're staying downtown, which is a fun area. Much less of the "puking in the toilets" college kid crowd and more of the young professional or Alumni back for the game crowd. For Friday supper, I'd hit up either Sweet Caroline's or Cornbred - both are on Main and likely walking distance from where you're at. If you're in the mood for pizza, Great Plains Sauce & Dough is an ISU institution that I've never personally been that into. Whiskey River is always a fun bar in that neighborhood as well as London Underground, and Sportsmen's. A bunch of the other bars have changed hands in the past few years, and I can't vouch for them either way.
On Saturday, go to the Tip Top when you get rolling for the day and then go tailgate. Just walk around with beer, don't be a dick, and you'll be welcome at most tailgates. I'm sure you'll see a shit load of "horns down". 99% of is good natured fun, but like anything in this day and age I'm sure there will be some assholes out there that will be trying to get a rise. An unfortunate reality and comment on society.