Officer resigns from Hooksett Police Dept. after investigation