Scotland's Roman Catholic archbishop resigns amid abuse allegations