A charlatan is generated once their NPC purpose is needed, unlike most other NPCs that exist before the start of the game. So technically speaking, there are no pre-made charlatans that can be found in-game, only computer generated ones. This is also the case of the Wise Old Man and Edward Dregg.
Unsavory uses the 2nd default Maxis face template in Create a Sim. He can easily be cloned in Create a Sim with debugging mode on. Unsavory has short black hair, a top hat, cape, waxed moustache and an Edwardian style suit. Even though he has black hair and grey eyes, his SimDNA reveals that his genetics are for red hair and light blue eyes.
This Sim has no character data and cannot be resurrected in-game. For more information, read this guide.
Do NOT attempt to add Unsavory Charlatan to a household, make him selectable, or tamper with him in any way or form. Doing so will corrupt the neighbourhood he is in.