Historic cathedral opened to public for first time