Council leader Tom Hunt has called for a “proper investigation” over pipes bursting over and over in a Sheffield district.