If you want to use SQL Server locally you'll need to install it on your computer or have remote access to a SQL Server instance from your local machine.
If you already have the public website and it has access to a database server, my suggestion is to build the site there, not locally.
Hope this helps,
Joe D.