The story
From piss + artist, variously from pissed as a synonym for drunk, take the piss out of as synonym for mock, and piss as a general term of contempt.
Etymology from Wiktionary, CC BY-SA 4.0.
piss artist
Today it means: Someone who is frequently drunk. Full definition →