A road left so badly damaged by a landslip it was used as a makeshift skate park will finally reopen after a £5m investment.