It is dependent on the processor, not the cameras, and will be available on all iPhone 11 models. Here is the press release for the iPhone 11 which mentions it:
https://www.apple.com/newsroom/2019/09/apple-introduces-dual-camera-iphone-11/
It is possible that it might work better on the pro models as having an extra camera available to the deep fusion engine might give better results.
https://www.apple.com/newsroom/2019/09/apple-introduces-dual-camera-iphone-11/
It is possible that it might work better on the pro models as having an extra camera available to the deep fusion engine might give better results.