Sumps use standpipes or overflow boxes that dont create a suction. If you had a pipe that had no siphon break then yes it would drain out the water. The overflow box and standpipes are matched to make sure that more water can flow into the sump than what the pump returns to the tank but at the same time they area also height adjusted so that in the event of a power failure when the water drains into the sump it doesn't drain to much out to overflow your sump. And for your last question yes the water will remain at a constant level as long as you keep adding water to the tank to compensate for evaporation thats why some people use reservoirs with pretreated water and and auto top off switch. This however does not mean that you don't have to do water changes anymore.