Following a well-meaning mayor of a haunted island town in New England, the show is as funny as it is terrifying