A Met Office weather warning will be in place from tomorrow night