A South Australian council has controversially voted to scrap the Acknowledgement of Country being read out at meetings.