I'm sorry, this is such an obvious thing to include in a paranormal pack. The way death is handled in TS4 is so poor: Townie ghosts that live on arbitrarily and more or less forever without any cont...
You could make something like a family mausoleum on a different lot and place the urns inside and make the mausoleum the meeting place of your family club so other sims don't get to enter.