No, thankfully, no NPC will actually die from Dragonrot. However, the halting of their questline and constant coughing will eliminate them from the story, removing their quest lines until their sickness is fixed.