School board member resigns amid sexual misconduct charges