I booked a room at The Rydges for $185 through wotif.com
I have never been there but the reviews on tripadvisor were good and we only plan to sleep there after walking own to watch the fireworks from Langley Park. But if our room has a view we may stay there. Might be worth ringing a few to see if they have a balcony with a view?
I'm so excited, DH and the kids have never seen the Skyshow up close
Good luck, I also looked on lastminute.com. Tripadvisor is a big help too.