Residents of Ireland’s haunted castles tell Michelle Cooney what it’s like living among spirits and how their ghoulish guests are helping to raise the profile of their historic homes