Canon DSLR seems to handle very well.
Canon generate the least noise when shooting at the dim light. For the reasonable price, I suggest 2 models. Either Canon 400D ( Rebel XTi ) or 40D will serve you well. But, spare your money for a tripod and a bright lense as well. Don't get them all at once. Find out what you really need and shoot mostly. Good luck.