An urgent review of water levels on the River Shannon and the need for one agency to oversee emergency flooding plans have been recommended in an Oireachtas report.