A sump pump is just the pump that moves the groundwater, typically from your basement to away from your house. You also need a sump pit, which is usually a perforated bucket or concrete chamber, to collect the water. You also need a float to control the pump. The weeping tile is the mechanism to collect the groundwater and move it to the sump pit. My house has a thick layer of gravel underneath the basement slab, which allows groundwater to flow to the sump pit, and no weeping tile, so if you have a similar arrangement, you may be able to get away with no tile.