I had a friend carve a pipe from a kit, and I stained it with shoe dye from a shoe repair shop. Came out great.
It's alcohol based. Just like regular stain, you want to use multiple layers and wipe the excess each time.
Sand with very fine sandpaper.
OTOH if looks aren't important the pipe will...