The story
From the habit of domestic cats of bringing home the remains of killed animals.
Etymology from Wiktionary, CC BY-SA 4.0.
look what the cat's dragged in
Today it means: Used as an ironic acknowledgement of someone's arrival, either jocularly or to imply that they are unwelcome or disagreeable in some way. Full definition →