CBD actually is the part in the weed that relaxes you and can calm the paranoia/anxiety caused by the THC. If you take a _lot_ of it, you might experience a similar kind of heavy-body type feeling you get with drugs but I wouldn't call it being 'high'.

It's kind of an issue these days because having something that's lower in THC and has CBD in it isn't as marketable as something with higher THC even though it would likely be a more enjoyable and relaxing high for most people. I believe CBD cannibalizes the THC to some degree so generally the higher the THC percentage in the plant the lower the CBD is, and even for someone with lots of experience it will give you more anxiety/paranoia.

In legal recreational marijuana markets, at least, there are often whole sections in stores that are dedicated to stuff that's CBD-only and high-CBD combos (there's some anecdotal evidence that CBD and THC have some kind of synergy that produces better results than pure CBD).

CBD is not psychoactive. So generally no. However CBD can have THC alongside it, which could have the anxiety/paranoia effects.