A Colombian senator who had been hoping to become the country's next president has died in hospital two months after being shot at a campaign rally.