Rain is finally on the way for parts of the UK after the driest July in England and Wales since records began.