If you have a standard view through DVC, request top floor, across from the bus stop, this will give you a view of the fireworks if there is not a tree in front of your balcony.
If your reservation is through CRO, they will most likely put you facing one of the pools.