A Scottish tourist who went missing in Naples has been found in a hospital.