Councillors have urged the Scottish Government, COSLA and NHS Scotland to provide the funding needed to ensure vital services can continue.