Monsignor Craig Harrison resigns almost two years after sexual misconduct allegations