I'm pretty much a city kid, suburban raised but always near a metropolis. But my guess would be that smaller towns and cities probably have pockets of pipe smokers that make their own community where it's always welcoming to pipe smoking.
Maybe down there near Myrtle Beach, S.C., where smoking pipes.com is located. I think the larger cities have pretty much regulated smoking. Manhattan still has a real pipe shop or two, and Chicago still has Iwan Ries, but in terms of having a welcoming spirit, big cities don't have that for pipe smoking.
The Lake District in UK is probably tolerant of old fellas with their pipes, being the home to the Lakeland blenders. You probably wouldn't be bothered, and you might even be befriended.
It reminds me of the song from "The Sound of Music," titled if I remember correctly, "Somewhere A Place For Us."