A leading loyalist who survived an attempted murder bid last month has been shot in both legs in a paramilitary-style punishment attack in north Belfast.