Depends on the country but it's generally a "thing" in Asian culture to prefer warm water or tea for drinking. Combine that with a mistrust of the tap water and you get nobody wanting water fountains.

Taiwan has them in train stations but nobody would trust them if they didn't have a chart on the wall with a detailed report of the weekly water quality inspection.