There are many mistakes:
The 9V battery plus must go direct to Vcc on the '174 , and to the 555. The battery minus must go to Vss on the '174 and to GND on the 555.
The 40174 is not a counter, it is just 6 flops with a common clock. To make it do something useful, you would have to turn it into a shift register or a counter. Even if you turn it into a counter, the oscillating frequency of the 555 must be less than 20Hz, or all LEDs will seem to light dimly.
Each LED must have its own current limiting resistor. All CMOS inputs have to be tied either to ground, Vcc, or another CMOS compatible output.