
Hugely variable is the answer to that. If you ride in the South or East of the county it tends more to the rolling rather than mountainous, but in the northwest of the county you have the Peak District National Park which contains a whole slew of great riding. Don't think you'll find any handbuilt trails like the North Shore ones though :).
The Yorkshire Dales and Lake district are fairly accessible too, so you'll have plenty of choice. if you're coming in March why not check out the Offroad Tour of the Peak website, it's an organised event that you could enter that should give you a good taste of Peak District riding. The URL is:
http://www.geocities.com/natsmtbclub/ortp.html