Sump systems are great for freshwater, can hold a great amount of beneficial bacteria. Long story short, the water is drawn into the overflow boxes, siphoned through the u-tubes, and carried down into the sump. The water will pass through the first side of sump, which is going to be filled with certain media to give a home for the bacteria, travel through it and on the other side there will be a pump that returns the water back to the tank.
Just make sure to clean everything up real well from the previous saltwater setup.