If the puppy is just sleeping in his crate overnight (and if you're 8 week old puppy makes it through the WHOLE night without waking you up once, I'm jealous!) then they don't need water from about 8 or 9 pm til the morning (about 6 or 7 say).
If it's too warm or hot in the room, then yes, the puppy will need water. But if the room is cool and the puppy is sleeping, and that's it ... they can certainly go the night without water.
All of my "puppies" had water taken away around 10 at night and then I put it down for them in the morning (around 5 am) and they were fine.
Marion’s Zoo-Kyleigh, Raylan-cat, Echo-TAG,