Scottish communities have been left to go to ruin while the public is put at risk by brutal cuts to council spending, a survey finds