A member of the House of Lords last seen swimming in a river in Wales has died, police have confirmed.