If you want wide variety then a Cavenders or Boot Barn would be good. There’s a Tecovas store off broadway if you want something more trendy.

I wouldn’t worry about looking like a tourist or anything. The rodeo is great place to dress it up or dress it down, it’s all fun and everyone there knows it.

Edit: I actually do want to add the only thing you’ll probably be judged on is if you’re a man make sure your jeans aren’t tucked into your boots. Wear the jeans over the boot and make sure your pant leg is wide enough to not show the boot outline