How can I manage multiple Photos libraries on my iPhone (iOS)
It is not possible to have multiple libraries with the stock Photos app on iOS.

However, you could use the stock Photos app to hold all the photos that you want stored on iCloud, and a seperate, third-party photo app to hold the rest. The third-party app could be something like Google Photos, Flickr or Amazon Photos.