A man has died after he was found seriously hurt in a city street, prompting police to launch a murder investigation.