Kempsey Shire Council Mayor given vote of confidence