Plans for a flood mitigation scheme for a major development for the regeneration of the Oxpens site is set to be approved.