Is there a way to create a notification in the Notification Center with a clickable link?
What you ask isn't possible with bare AppleScript. 

There are 2 possibilites I'm aware off : 


Using Terminal Notifier : A CLI binary which will allow you to create notifications
Using Notification scripting : A .app which can be called with AppleScript to create notifications.