Survey shows residents view of council improving