[77ko]

If you use a pressure reducer -> good quality bidet with metal pipe -> to a simple head which is openable and fixable, should last a long time, mine is approaching 10 yrs and should keep going. The flexible pipe will need changing in a few years probably and the bidet itself will need a new spring + washer if it starts leaking.

You could also go full hackernews and have a sensor connected to a wifi valve which shuts off the water supply when no one is in the loo.