What is your objective in buying a liquid cooler?
If it is to get some RGB "bling" then there are better ways.
What is the case you would mount it in?
AIO means "all in one" That is the radiator, tubes, pump are all connected and the tubes are filled with coolant. This is different from a custom loop(expensive) that has a coolant reservoir that can be refilled when needed.
AIO is essentially air cooling, the difference is where the radiator heat exchange is located.
With such as a H60. you mount the radiator and fan somewhere. Usually as a rear exhaust in the case of a 120 size aio. You mount the pump on the cpu in a similar manner to an air cooler.
The pump circulates fluid to the radiator where heat is exchanged.
AIO coolers do not last forever. In time, air will intrude into the system, making it ineffective.
These air bubbles will rise to the top of the system. If the pump is at the top, the pump will no longer circulate fluid.
All coolers start with the ambient temperature. That means the temperature of the air used.
This can be outside air which is room temperature, or it will be the temperature of air inside the case which will be higher. Most any cooler can keep a cpu at 10-15c above the ambient air temperature.
If your room temperature can be 40c(104f.) ouch.! not much will help.
Do a simple test:
Start Hwmonitor. It records the current, minimum and maximum temperatures.
Then run a simple CPU-Z stress test.
After a bit, look at the minimum temperature.
The cpu will monitor it's own temperature.
If it detects a dangerous temperature, it will throttle or slow down to protect itself.
Then, look at the maximum temperature.
If you see a temp in red at 100c, it means that you have throttled.
Noctua maintains a database of suitable coolers for processors.
Here is the list for the i7-7700k:
https://ncc.noctua.at/cpus/model/Intel-Core-i7-7700K-288
On the list, NH-U12s would be ok, but to get the most out of your 7700K, you should go stronger.
I would think such as the H100 would not be strong enough.
To answer your question, aio coolers DO on occasion leak.
Not often though.
But, if they do leak, the consequences are nasty.
A aio vendor may warranty that damage, but it is a mess to recover from.