Councils have rejected Government calls to bring back weekly rubbish collections, a survey has revealed.