The Cambridge city manager has announced his resignation, citing concerns over the controversial harbor project.