One of Scotland's most respected and lauded journalists, Stephen McGowan, has joined The Herald's sport team.