Do your sims ghost stay or do they disappear?

They stay until you delete the headstone or urn, which is the source of the haunting. After which life returns to normal.