Weekly food waste collections will be turned into renewable energy and fertiliser, a council says.