I think the courtyard rooms have the best "guaranteed" view. They look out over the inner courtyard and pool. However, there are some woods view AND standard view rooms that have a view of the castle and fireworks. But, it is the luck of the draw if you get one.
As far as requests, make them when you make your reservations. If you have kids, request bunk beds, they love them. Or at least mine do.