Forward biasing of a BC547 transistor doesn't turn on LED
The base-emitter volage Vbe is typically 0.7V maximum, but that is the voltage between base and emitter, not the absolute voltage relative to ground. With R1=56k and R2=10k, the voltage at the base is 0.75V, leaving only 0.05V between the emitter and ground. The diode D1 also needs a forward voltage to turn on. Assuming D1 is a typical red LED, it needs about 1.5V.

This circuit could be made to work if you change the values of R1/R2 to set the Q1 base voltage to the correct voltage, and reduce the value of R3.

Assuming the D1 forward voltage is 1.5V, and the desired current is 10mA through D1 and R3, then the Q1 emitter voltage Ve must be 1.5V + (10mA * R3). Note that with R3 = 330 ohm, Ve must be about 4.8V. If you're trying to run from a 5V source, use a smaller value for R3.  Finally, select R1/R2 ratio for Vb = Ve + 0.7V.