It has little, if anything, to do with the water. Ice made in a freezer is cloudy because of air bubbles. There are techniques for making clear ice using directional freezing. Here's one way: https://altonbrown.com/recipes/cocktail-ice-cubes/