Huge floodgates are to be installed to better protect hundreds of homes and businesses