Parts of Scotland are set to become wet and windy on November 5, as other areas across the UK will have more promising clear skies for the fireworks.