Hi Mat,
Welcome to the Q&A Forum.
Other than a digital single reflex camera, there is no question that the best compact digital camera for low light photography is made by
FujiFilm that has a Super CCD (not all FujiFilm cameras have a Super CCD).
Some of their older models have actually received better user recommendations than some of the newer ones that have too high megapixel count.
If I were to buy a FujiFilm digital camera, I would purchase any of the following, some have manual controls, other do not (in no special order):
FujiFilm FinePix F40 fd
FujiFilm FinePix F31 fd
Fujifilm FinePix F30
Fujifilm FinePix F20
The cameras are not widely available locally, at least in the US where I live, so you may have to order online if you decide to purchase one.
Here are some tips about buying a digital camera online:
http://www.digicamhelp.com/buying-guide/shop-online/Related reading:
Compact digital camera vs a DSLRhttp://www.digicamhelp.com/buying-guide/camera-types/dslr-ps.php