8-10 cereal bowls a day?
I'd give the water at room temp or slightly colder.
If your Yorkie continues, I would wonder about diabetes insipidus.
An average estimate would be one ounce per pound daily if they are eating dry kibble. So a four pound dog would drink about 1/2 cup daily give or take...