From locals to visitors and children to adults, San Francisco was packed for New Year's Eve, with many eagerly awaiting the annual fireworks celebration.