Scotland's Roman Catholic archbishop, mired in abuse claim, resigns