Speak to him to enter The Haunted Manor.
This NPC is found in multiple locations. The map below shows where the NPC is first encountered.