I think it’ll look awesome! For function and possible stability, you may want to consider a small, metal tube to help connect the shank and bowl. From what I understand, MM used something similar when they made their recent run of bulldog shaped pipes (The Corndog) for their anniversary.The last part I can guarantee. The functional part, not so much.
There's a technical challenge, and an artistic challenge on mine. Neither will be easy. I'm planning on starting with a Little Devil Acorn, with the bowl sat upright, and the stem pointed down.
View attachment 1166831
That then needs splicing into... something... so a stem can be mounted in a bent position further away.
View attachment 1166832
That's the technical challenge. Trying to both get that smokeable, and also have the joint in such a way, that a pipe cleaner can find its way into the bowl.
Then the artistic challenge is building round it...
View attachment 1166833
...so I end up with something like a meerschaum claw, but holding a cob.
View attachment 1166834