As I see it, the 24-70mm f/2.8 L is a good option for indoor low light situations. I'm considering it myself. I find the 24-105mm practically useless indoors without a flash.
For outdoor at night, I would also prefer a prime in the f/1.2 to f/1.8 range. But it is true that good ISO performance can get you a few extra stops.
I'm also considering the 35mm f/1.4 L, but more for the IQ, bokeh, and low distortion (compared to my 16-35mm f/2.8 L II), than for its low light performance.
One thing to consider... let's say that you need an f/2.8 depth of field... well, then your ability to shoot in low light is primarily going to be a function of ISO and IS. That's something to think about. Just because you have a wide aperture, doesn't mean that the resulting depth of field will suit your needs.