San Francisco’s mayor is to seek counselling for alcohol addiction following the disclosure that he had an affair with the wife of a veteran aide.