if your want the game to look realistic i would recommend creating a physical noise on the terrain, for example use the erode scupt tool to physically make the terrain more noisy in shape, THEN apply the texture to it.
You could always just add a black and white “cloud” (photoshop filter) to the material in order to make it look better but that would require much more work in the material. though it would come out at a higher quality.