A man has been left with what police have described as ‘life-changing injuries’ after he was shot in Yorkshire.