Hi @Nishant Jain , welcome to Microsoft Q&A forum.
As I understand you want to deploy the schema of database at the time of server creation.
We can do it with the help of importing bacpac files with ARM templates. Firstly we need to create the bacpac file and then use the url of it in ARM template. Please refer to below article that has the details related to it:
Import SQL BACPAC files with ARM templates
Please refer to completed template and let us know if you face any issue or have any other queries.