Does unity give the player the ability to modify terrain in game real time? I am looking at a contruction style game where the player would build up terrain.
Yes.
Search in Unity Answers for Terrain SetHeight, and http://unity3d.com/support/documentation/ScriptReference/TerrainData.html for the references.