Most puppies can hold their pee overnight, once they are at least 4 months to 6 months of age.
Before 4 months to 6 months of age, puppies have little to no bladder control and will urinate through the night and not be able to hold it.
Younger puppies also have smaller bladders and will need to pee more often than older puppies.
If the puppy is not able to hold their bladder or pee overnight it's best to put the water up during the night but leave it out during the day.
Puppies should always have access to water at least at all times during the day.
However it's okay to put the water up at night to prevent the puppy from having to pee at night so much.
I always kept water out for the puppies and dogs during the day but at night I would put the water up and then put it back out the next morning.
As long as the puppy and dogs are getting enough water through the day then they will be fine to go without some water through the night.
Puppies when they drink through the night will need to urinate more and are more likely to have pee accidents in the house or in their cage or crate at night.
So it's best to just put the water up at night and they will be fine.
Puppies will also drink when they are thirsty and so will the mother dog so having access to water at all times during the day is needed but at night they will be fine.