Depends on the age of your pup. Mine was 8 wks when I brought her home and for the first couple weeks I got up every time she started to stir which was every 2 hrs at first!!! It was like having a newborn. We finally got it down to 3x per night and then she ended up with a UTI and we were back to getting up! I was exhausted as I was getting up at 5 a.m. to work and I don't do well with lack of sleep. My pup is in my bed so when she started to move around I knew it was time to get up. My older dog slept in a crate that was elevated beside my bed and she would go out maybe once a night but she almost always peed in her crate- probably because I was asleep and didn't realize she was up and about. Once they were about 3 mo they slept through the night. It just takes a little time for them to hold their bladder all night.
You may want to pick up the water bowl an hour before bed time as well but even then if the pup is young they'll still need to go out during the night.