A Saudi royal, known as the "Sleeping Prince," has died after spending two decades in a coma following a car accident, the country's royal family has said.