When your Cloud Site was created we automatically created an FTP address for your site. Use the management URL included in your welcome letter as your server name and the user name and password included in the welcome letter as your FTP username and password.
Content for your website should be placed in the wwwroot folder. The wwwroot folder is the only folder that is accessible over the web.