Storm Bert is set to bring a “multi-hazard event” this weekend, according to the Met Office.