It's \$V_{CC}\$ rather than just \$V_{C}\$ because the C stands for collector. But \$V_{CC}\$, though a collector-side positive voltage in an NPN transistor circuit, is not the voltage at the top of the collector, \$V_C\$! There is usually a load resistor or some other device between the collector and \$V_{CC}\$. The doubled-up C indicates that it's a higher voltage beyond that which appears on the collector and is clearly distinguished from from \$V_C\$.
The letters denote transistor parts: source, drain, gate, collector, emitter, base.
When there are two different letters, the meaning is different: it means the voltage between those terminals of the device, like \$V_{BE}\$: base to emitter voltage of a BJT. This is possibly why a doubled-up letter was chosen for \$V_{CC}\$.
Let's invent a rationale.
Suppose want a name for a voltage associated with the collector which is not the voltage at the collector. Suppose we want the name to be as short as possible, but we want to include the letter C to clearly associate it with the collector. This means that the name will be two symbols long: C plus another character. The other character will be a letter, number or some other kind of glyph. A number would look like a voltage, so the choice is between using a glyph like ampersand or hash, or a second letter. If it is going to be a second letter, then it cannot be any other letter beside C, because then it looks like the \$V_{XY}\$ notation denoting a voltage between two points. If the C is repeated, then we know it cannot be the useless designation of the voltage from C to C, which reminds us that the notation has another meaning. If the second character is going to a glyph, then it should probably be something other than + or - because these look like polarities.
So the shortest possible way to denote the collector-side supply voltage is either something glyph-based like \$V_{C@}\$ or else \$V_{CC}\$.
Clearly, an argument can be made that \$V_{CC}\$ was a sober, well-considered choice to express what the inventor of the notation wanted to express, which caught on.