The warning covers parts of southern Scotland, northern England and North Wales