A new exhibition is set to open celebrating the former royal photographer's works that are a far cry from his more formal portraits