A council in Sydney’s north is considering charging spectators to watch the city's new year's eve fireworks from popular vantage points.