A house described as the “most haunted” in Ireland has opened to the public for the first time in over 30 years — just in time for Halloween.