The man was said to be swimming while exploring the beauty spot with his family when the tragedy struck