If you are versed in the scientific names of plants at all, then you may realize that Sciadopitys verticillata is not a true pine, despite its common plant name. True pines have Pinus in their botanical names: for example, botanists call the eastern white pine Pinus strobus.
As trees go, this will be a small one in your landscaping for quite some time, assuming you buy a young sapling. It is a slow grower. So even though it may eventually attain a height of 25 to 30 feet (although it grows considerably taller in its native habitat) with a spread of about 15 to 20 feet, expect it to remain a much smaller specimen for many years.
As it starts to get taller, it will assume a form that is pyramidal or "narrowly conical." How narrow a form, precisely, it does assume will depend on a number of factors, including whether or not you allow multiple trunks to form and whether you prune. Long-lived, it may outlive you and may put on much of its eventual height only during the life of the next homeowner who takes over from you.
Japanese umbrella pine trees are indigenous to Japan. According to PlantExplorers.com, it is "one of the five sacred trees from Japan's Kiso forest." In terms of the USDA map, they grow best in planting zones 5 through 8.
Japanese umbrella pine trees are chiefly used as specimen plants. While they function well in that role year-round, they are especially effective when deciduous trees are bare; that is, as is often the case with evergreens, they are most appreciated for the visual interest in winter that they afford.