The problem is, that templates are just templates. You need to have deep knowledge about the "web stuff": how a http server works, how the browser and the server interact, how a http request-response pair looks like, what statelessness of http means, about html, javascript, css and of course the database engine you will use - I suppose SqlServer. That is a really good piece of knowledge you will have to acquire.
Let's start with the template: I know of none, that will bring you closer to your specification. Actually, I would use an empty ASP.NET MVC4 (or WebAPI) site template. But that's only a skeleton.
About the tutorials:
I would start with this one:
http://www.jmarshall.com/easy/http/[
^]
Here is a good CSS tutorial:
http://www.html.net/tutorials/css/[
^] and one for html:
http://www.html.net/tutorials/html/[
^], and javascript:
http://www.html.net/tutorials/javascript/[
^].
And finally, the official ASP-NET MVC tutorial:
http://www.asp.net/mvc/tutorials[
^]
Submit an article or tip