A spook-tacular vacation destination: Inside America’s ‘most haunted small town’, whose cast of ghostly characters inhabit an eerie mansion, an abandoned hotel and an Irish pub