Creating Intranet with Wappler

Nothing you specify looks to be a problem.

To advise on local server, what backend language do you intend to use? Node? Php? .net?

Every technique you will need to create and manage the data is covered in this course. While it is based on node; as wappler "protects" you from having to code and manages the backend for you, only using layouts (which i believe will also be coming soon in wappler for php ) are language specific.