OK, the two parts are separate, just working from the same 12V supply.
The water level part would use a relay wired in a self-latching circuit, like this:
The float switches replace the push buttons; both float switches are set so they close when the water level is higher.
The high level switch acts as the top button to latch the relay in, the low level switch acts as the bottom button, disconnecting the "hold in" link through the relay contact when the level drops too much.
The second contact on the relay switches power to the fountain pump.
The motion sensor output contact could directly operate the water solenoid valve, if the contact rating is high enough. Otherwise, use the contact to switch power to a relay coil and use a contact on the relay to switch power to the solenoid.
(Omit the push-to-break switch and the connection it uses through the relay contact in that relay drawing, so the motion sensor acts as the top switch. Without the latch contact wiring, the relay just follows the on/off action, but can switch much higher currents, depending on the exact relay you get).
The easiest ones to work with are either cradle relays or octal / 11 pin types that you can get with screw terminal bases.
Cradle style are typically rated to about 5A (some 10A) through the contacts, octal are normally 10A.
From a quick look on ebay; rectangular / cradle style:
**broken link removed**
Octal relay,
Find many great new & used options and get the best deals for 6012-9012-0040 Finder Relay DPCO 10a 12vdc at the best online prices at eBay! Free delivery for many products!
www.ebay.co.uk
And a base to plug it in to:
The 11 pin style look similar but have three change-over contact sets and three more pins.
The smaller cradle type generally tale a bit less current to operate the coil.
Note that in a practical circuit the relay coils and solenoid valve need "flywheel diodes" across the coil connections.
Without those, the contacts controlling them will arc due to the inductive flyback kick from the coil.
This shows the basic connection, straight across the coil terminals with the diode cathode (band marking) to the positive side.
1N4000 series diodes are easy to get and OK for that use in small power circuits like that, eg. 1N4002 or 1N4007 ( or anything in between).