Former police officer resigns after caught allegedly faking his own death