Night works to begin on council’s largest road upgrade