My puppy has 24/7 access to water even in her crate. I use this. It works really well for me.
I have a separate bowl in general area she hangs out in but sometimes she'd go in her crate for water too. She doesn't over drink or cause any spills.