operative, pi, private detective, private eye, private investigator, sherlock
house detective, house dick