I have just had CCTV installed outside my house.
The app has been downloaded onto my iPad so I can watch it anywhere.
Can the app be downloaded on my son's ( who lives miles away) tablet? So he could also keep an eye on the house?

Yes, no reason why not.