A view not seen for "more than 300 years" will be revealed by a multi-million pound development of one of Nottinghamshire's ...