Hanover police detective resigns amid investigation