Political leaders on a Scottish council have reaffirmed their commitment to being a "Council of Sanctuary"