A newly completed £4 million commercial building has been opened in tribute to a late Ripon businessman....