Spotsylvania sheriff resigns