One of Scotland's most decorated police horses is heading off to pastures new to begin his well-earned retirement after more than a decade of service.