Whether or not you decide to give your dog water during the night is ultimately up to you. Potty-trained adults should always have access to water throughout the night. There shouldn't be any problem with them sleeping without needing to urinate.