More than £40,000 has been redirected from a Rotherham Council fund to help small businesses reduce their carbon emissions, after experiencing lower-than-expected demand for the financial support.