The basics: SugarHouse Casino will put on two fireworks shows on New Year’s Eve that will take place along the Delaware River Waterfront. But what’s New Year’s Eve without fireworks in Philly? The good news is that are plenty of places to catch the two big fireworks displays on the Delaware River Waterfront-for free! As the holidays come to a close, chances are your wallet is feeling a little light.