I saw a This Old House episode several months ago where a small mechanical water leak preventer was placed inline at the shutoff. Do these devices work well? Are they one time use? What is the name of this device and where can I purchase?

Thanks,
30Abuilder