Charlton Athletic have earned promotion to the Women's Super League for the first time in their history after defeating Leicester City in a dramatic penalty shootout.