An investigation is underway after a man was tragically found dead in the River Irwell.