We did it last year and it was great sitting on the lounge chairs, toes in the sand looking across the lake, towards the castle. Then stay and wait for the water pageant parade to float by! We were not staying there at the hotel, just decided to eat there that night and view the fireworks afterwards.
Go and enjoy yourself!