A motion accusing a water company of a “serious lack of coordination” after shortages in the hot weather is being brought before a council.