Is there any way to add google drive new button functionality in google sites using any google API/Google Apps Script
All of the functions under the New button can be implemented by their corresponding Drive API equivalents. I'm not aware of a drop-in library that you can use, so afaik you'd need to write it yourself.