This carved work is based on a dwarven pipe design by John Howe; you can see it on the Weta artbook: “The Hobbit: An Unexpected Journey, Chronicles”.
This model is functional, and is made in apulian olive wood (tobacco chamber and the bird “shank”), ebony (the black ring), and horn/dark grey methacrylate (the stem). This model hasn’t never been realized for the movies, I think.
Watch the video here.
This pipe can be made on commission. Some details are customizable.