A musical society with a show-stopping history has been given the rights to present the Irish premiere of Ghost: The Musical.