The BBC sparked upset earlier this week when it announced that long-running soap opera River City, which is filmed and set in Scotland, will be coming to an end next year