If your focus is pipes, you options locally are zero to nil. Back in ancient times, us olds had numerous places - Colson's Corner (which later became Sarita's (then Sam's) Smoke Shop, and the Tinder Box).
If you're looking for anything resembling an old-time smoke shop, you'll need to go down to either The Woodlands or Houston.
If you don't want to travel, the best bet would be to go online. Two of the bigger retailers are:
Smoking Pipes
https://www.smokingpipes.comPipes and Cigars
https://www.pipesandcigars.com