A noise free camera will never happen. Stochastic processes will guarantee that.
However, what many fail to realize is that noise-free human spectators already exist. Just give them an interesting picture to look at, and they'll forget about the noise.