How can I give someone server access to only duplicate and modify a site?

Well, you can use a plugin like Duplicator to create an installer package of the complete site including database etc. which the user then can install in a new database & website path.