Edinburgh could move away from large public firework displays in the future, according to the city council's new leader.