I see them for sale at Medieval Fairs, but I imagine there are online shops that offer them.
Because of the novelty, they usually aren’t as cheap as one might expect.
Thank you for helping me convince Mrs Bizzle that I need a lathe
Looks like a briar pipe of some kind. I don’t really know my pipes but I think it could be a churchwarden or a sherlock style.
There are plenty of online shops that would sell similar pipes. It’s a question of how close to the photo you want it to be. I think a high quality briar pipe can run a few hundred dollars. However, you should be able to get something for 30-80 USD if you look at entry-level options.
I sometimes enjoy smoking from my long stemmed 18th century replica clay pipes, which I purchased from pipeshoppe.com. Historically, clay pipes were cheap to produce and somewhat disposable. Even today a fancier clay pipe can be had for <50 USD. However, their current selection of wooden pipes is a bit sparse so you’d have to look elsewhere to match what’s in the photo.
Tobacco shops might sell these wooden pipes. I used to see them when I’d go in there to buy cigarettes but I stopped smoking cigs like eight years ago tho
Bavarian tobacco pipe, might be a good search term.