The former lead detective in the investigation of the murder case against Oscar Pistorius has resigned from the police force, South African police say.