The final finishing touch has been put to a facelift given to a major Preston street - almost three years after work began.