Who takes over a life insurance policy when the policy holder dies?

If the policyholder (policy owner) is also the insured, then no one does. The policy proceeds (assuming the policy is in force at the time of death) are paid according to the designated beneficiary(ies), and the contract ceases to exist. If the policyholder (owner) is not the insured, then the policy ownership would flow according to the owner's will.