San Francisco's residents are set to have their say on whether the city introduces a tax on sugary soda, according to reports.