From cat + piss. The marijuana sense is from the perceived resemblance of the smell.
cat piss (uncountable)