How to reconfigure resistor value from a working circuit
You seem to have 2 different problems (unless they're the same one). The first is the hot resistor. According to the schematic, R4 is a 47 ohm, not 470, but that's OK, since the 470 ohm (R6) is less likely to overheat due to its larger resistance. The other problem is the red LEDs coming on.

Try this. First, disconnect the common R7/R12/R17 from Q2. All LEDs should be off. Set the input amplitude to zero. Now check the voltage across R4 and R6. R4 should be very low, while R6 should be about half the supply voltage. You've clearly wired something wrong. My first guess is that you've reversed Q2.

I notice that you have no power supply capacitor. Try adding a 10 or 20 uF cap from power to ground, and do it physically at Q1/Q2.

If, with the 3 resistors disconnected, any of the LEDs lights, you have a problem with that section's circuitry.