There are quite a few people with different species of pipefish in their reef tanks. I recall PaulB has pipes in his reef tank...as well as a few other people. As seamonkey mentioned, dragon face pipes, I've heard, can be successfully added to a reef.
Tom