Northern Ireland leader resigns after sex allegations