Some people are into it as a fetish, some people think it's for good health to drink your own, but it's not very common at all. Best advice is to google the subject.
And the only way to know what he'd like is to ask.
There used to be an ancient practice, associated with many European countries, of medicine men, or some caged large animal -like a deer, eating a bucket load of magic mushrooms.
As soon as they'd gone off their trip, stopped convulsing, & hopefully hadn't died, the villagers used to wait to drink the excreted urine - because the drug would pass through unchanged, with fewer of the deadly effects - though of course, the hallucinations, & mild mania were the supposed benefits.
So drinking someone else's piss, including an animal's, in order to get high, means it's still in most of our genetic makeups.
Thank God for better chemists!
As for being pissed on - I think that's really something to be left to enjoy by people with no sense of smell.