I never did sugar water, but we did put honey in the water because our yorkie was extremely sick and very hypoglycemic. He would go into hypoglycemic episodes all the time
In most cases it's on an as needed basis, but with my yorkie, we had to do it continuously because he was so sick. I just put a tsp of honey in his bowl of water per the vet's instructions.