We watched it from the bridge from the courtyard to tomorrow land. AWESOME location. You can see the castle with the fireworks above. Also you want to be where you can see the castle because they project stuff on it.
It is definately a show that you do NOT want to miss. The music is great and they go through a LOT of fireworks for the show.