Man dies following major river rescue at Glenrothes park