A huge snowfall overnight on Tuesday is expected to cause travel disruption through the morning in southern Scotland and Northern Ireland.