Hosts of the council-run event were left red-faced when the full light display failed to come on not once, but twice