The government must secure value-for-money spending when executing flood protection plans, according to a public spending watchdog.