Yes, I have noticed those couds of bubbles in various contexts and can even create it in clear water if I can apply an air pressure pump to clear water.
What causes it is air dissolving in water under pressure, then bubbling out when pressure is relieved. If you have a garden pest spray of the type that you pump up with air, then clean it out nicely, fill it nearly full of cool water, begin to pump in air till you can no more. Let it cool and swirl the pump round for a minute or two and things settle. Then pump again till you have had enough. Finally you wait till all is still and you gently screw off the top and quickly, but gently, pour it into a glass. It probably will make a nicely cloudy pour, but the bubbles will soon rise to the surface and vanish. If you then leave the glass for a while, then especially in an old glass, you are likely to find that the surface underwater becomes covered with bubbles.
Now, under high pressures in pipes, bubbles of air dissolve in the water and bubble as pressure is relieved. This is what causes decompression sickness (the "bends") in our bodies when we dive deep and surface too rapidly.
In domestic pipes it is not all that common, because the pressures are usually low, but i high buildings pressures are high and such clouds of bubbles are common. I have know it to happen in the water from deep boreholes.
I hope that helps.
Jon