A yellow alert for fog has come into force, with the Met Office warning the weather could cause travel disruption including flight delays or cancellations.