CSU chancellor resigns over handling of sex misconduct case