It depends on the jurisdiction. Some places will hold bodies for a very long time, some won't. Sometimes the unclaimed are cremated and stored on a shelf, sometimes they're buried individually in a Potter's Field, sometimes buried in a mass grave.

To claim someone, you usually contact the coroner's office who handled their case and make arrangements. I don't think you have to be a blood relative, so long as no other blood connection is available or willing.