Historic cathedral to reopen after major two-year renovation