Northern Ireland leader stands down