I tried an experiment using copper foil and the same size pipe used for the pump inlet. The pipe is US schedule 40, 1.5 inch PVC (48 mm OD, 41 mm ID). The copper “plates” are 50 mm x 200 mm. Setup is in the pic below. Empty and dry, C = 12 pF. Empty but with a wet interior wall, C = 14 pF. For full vertical position, C = 31 pF. Surprisingly, for full horizontal position, C = 55 pF. Rotating the pipe in the horizontal position did not change C. And surprisingly, pipe half full in horizontal position also had C = 55 pF.
So, is there a circuit schematic available that can operate a relay based on a capacitance change of only ~40 pF? Would very much prefer a pure analog circuit … no microcontrollers. Tried searching online without success. When “capacitance” and “relay” are search terms, most of the results are about time delaying a relay.
An off-the-shelf device would be even better if not too expensive.
Based on these results for capacitance, a circuit can be made according to my reply #3 above. But before I describe it, let me explain why I did not suggest a measurement device like the one gamelot suggested in reply #4. There are perhaps a dozen capacitive measurement ICs available, which have in common that you don't have to worry about measuring, but about the digital interface instead. So if you're a digital guy, have your MCU development system ready and know it, or if you need very good accuracy, this is the way to go. Otherwise, you loose a lot of time to get the MCU running, although the software will be quite trivial: Configuring the measurement IC, triggering, reading results back.
The approach I suggested can be easily implemented as a cheap one-chip solution with almost any quad opamp IC:
An oscillator Vosc feeds a series connection of a resistor Rref and the sensor capacitance Cs. The voltage at M will depend on Cs. Opamp U1 amplifies this voltage. It is connected non-inverting for high input impedance, because M should be loaded only lightly. The amplified signal is AM-demodulated by D1, Rd, Cd. This provides us with a DC voltage that depends on Cs at node 'demod'. But the two voltages for full/empty pipe have the same sign, which means we cannot yet feed this into a Schmitt trigger. The level shifter U2, which is actually a summing amplifier, corrects this by adding a negative voltage, such that the levels now have opposite signs. The Schmitt trigger U3, as usual, acts as a comparator with hysteresis, such that the output is not switched too often. That makes 3 opamps, the fourth in the package can be used to make the oscillator. Note that this generic schematic does not use a specific opamp type, because many will do, and that the stages U2, U3 will need a pot to adjust.