The council's common good funding could be used to pay for a public fireworks display in Glasgow according to a councillor.