There's no indication that Fredo's body was recovered. We don't know what happened to it. If it was dumped, Lake Tahoe is about 1,500 ft deep and the body would be subject to the ravages of that water environment. Since Michael ordered his brother murdered, I don't think he'd be concerned about living there.