Norwich's 'at risk' Roman Catholic Cathedral has been handed a boost to help protect it from further deterioration.