Good summary there by Ralph. A lot depends on just what you want out of your vacation. I have just spent a few days up at Tranquility Bay, on Ambergris Caye but nowhere near San Pedro. A great spot for a diving vacation, but absolutely no night life.
Thatch Caye (a private island just off Dangriga) would offer similar, but in a different and in my view superior diving area (the Southwater Caye Marine Reserve). Again, no night life, but it's remarkably easy to get to the mainland and go on tours - they do the whole lot with their own boats and mini-buses.
San Pedro itself is a fairly busy place, though not particularly so in November, and can offer quite a lot to do at night. You can stay a little outside and get all the benefits a largish tourist destination can offer, but without the noise and bustle. Somewhere like Victoria House is a very peaceful home-from-home with everything close by but not directly in your lap.
A lot depends on your budget. Belize is not a cheap place, and it would be a shame to spend all your budget on an hotel and not have anything left for the many activities available. If you look at
Belize Vacations, Tours, Resorts, News, Hotels, Travels, Flights, Weather, Maps, Real Estate you'll find a lot of information about much of Belize, not just Ambergris Caye. Including many maps, accommodation guides, diving guides, and lots more besides. have a look there and come back with any further questions.
November is not a busy time anywhere in Belize, so you can take your time, do your research, and come up with something that really suits you without fear of finding it all booked up. Do remember, you have the option of a two-centre holiday, and I'd choose somewhere by the sea and somewhere inland in the San Ignacio area. Even if you don't opt for that, do allow for a few inland tours or you'll be missing out on a lot of what Belize has to offer.