Herefordshire Council has approved a £2.055m investment over the next two years to boost flood resilience for homes, businesses and infrastructure.