I'm not sure that the OP wanted to put his vacuum in the tank, but maybe wanted to use the concept of the cyclone air/solids separator (the basis of the dyson cleaner) to return clear water and separate out solids. The design of the cyclone would be very very tricky since the air/solids separator works so well because the denisities of air and solids is very large, around 3 orders of magnitude. For example, air is about 1.2 kg/m^3, whereas water is 1000 kg/m^3. Silicate sand is around 2500 kg/m^3.
That difference of 2.5ish between water is sand means that a very, very large cyclone would be needed to separate the two. And secondly, all the solids in the tank have difference densities. Making a cyclone that would only take out fish wastes, but leave the sand alone I'm guessing would be impractical to impossible.