If you want to stay on site, both the Dolphin and Swan are starwood properties. Off site, there's the Sheraton World Resort. Ask for a room in the tower - they are the newest. Hotel is very kiddie friendly. Don't know about the fireworks. If you do see them, they'll be from Seaworld which is right next door.
www.sheratonworld.com