Police arrived to find the man, in his 40s, dead at the scene after concerns for a person's welfare were raised