A stretch of motorway linking Scotland’s two largest cities is to shut overnight for almost two weeks.