Officer accused of DUI while on duty resigns