Drivers face overnight closures and detours as part of the £25 million investment