Cloudy water in an aquarium is usually indicative of a bloom of bacteria (or algae, especially if the bloom is green, but I will come to that later) as they munch on the waste produced by fish. As they eat through this waste, they produce the breakdown waste, known as ammonia.