I don't get turned on by the pee itself but when my BF pees, he moans and grunts, and he's touching himself lol... so that gets me a little roused... other than that, no pissing fettish here...
I don't think you should have any qualms with it if you both are comfortable though. If you're not comfortable then don't do it, simple as that.
For me, I think I get turned on by practically anything my partner gets turned on by simply because I like to please... so if I were you, I would do it.