Royal College of Nursing union chief resigns amid mounting anger over NHS pay deal