I'm planning a campaign loosely where players have to fight enemies backed by a larger, scarier empire that frequently sends out their agents to try to assassinate them while they try to setup a new kingdom post-revolution (think the beginning of Game of Thrones where players are on the Small Council, but they're also sort of Danaerys trying to fend off the spies and assassins of the enemy kingdom's Varys).
I want there to be a lot of cloak and dagger stuff. The players will probably have to protect themselves and fellow members of the court, the monarch (whether it's a player or NPC), allied diplomats, and such from assassins while also rooting out spies. Those resulting battles, along with adventures that I'll incorporate with diplomatic missions abroad, are what will make it DnD.
But it occurred to me as I was planning the worldbuilding for this campaign that a lot of the danger of assassinations will be lost if they can be undone by resurrection magic. Then I started wondering how kings, organization leaders, criminal syndicate bosses, basically anyone important ever dies in any high fantasy DnD world. For players I can restrict their access to diamonds or whatever, but for NPC's who are rich and powerful, not sure if that makes much sense. Besides, it's okay of players have access to the magic, but I want NPCs to be threatened by it, because it adds drama and stakes to the story I'm planning. But if players have access to it, then basically no NPC around them is in danger either, and I lose a lot of the tension I was counting on.
So looking for advice on how you would solve this. Tl;dr: How would anyone important or rich die in your fantasy world from stuff that are not old age? (assuming you want a fantasy world like I do where death is a dangerous possibility)
Restrict the resurrection spells? Restrict diamonds even more so they're rare even for kings? Manipulate the religion or cosmology of your world somehow? Do something with the resurrection spells themselves, like like Matthew Mercer's optional rules? Something else?
Resurrection could age the person involved so that they would die sooner (say 10 years for humans and scaled to the lifespan of other races) from natural causes, multiple Resurrections could lead to a person that dies again only days after being raised.
Resurrection could have a chance to fail (say 12.5%), making the person forever dead and with each subsequent resurrection doubling the chance of failure.
Resurrection works but is not perfect and the subject is weakened by it. Eg: the person loses ability scores (say -2 con and one other ability score at random).
Resurrection works but the costs increase dramatically each time. 2nd is 10 times more expensive, 3rd is 100 etc.
Or resurrection works as normal but the body must be whole. All you need to do to make an assassination stick is to behead the person and take the head with you or burn the body.
Hell, just sprinkle in some pissant gods of death/life/order/whatever with intrinsic notions of how Things Are Done Around Here and alluvusudden, those back to back resurrections'll earn you a visit from middle-upper management.
I could imagine gods that are strict and by the book, tired of all the paperwork they're getting from clerics below for special exemptions just because he's, what, a king or something?
The last one makes me think of adding a poison to the world that has the secondary effect of disintegrating the body. It would be dramatic to have someone drink something at a fancy dinner, then choke and die, and then suddenly melt, or burst into flames.