Former Church of Scotland Moderator welcomes pledge to end rough sleeping