A "magnificent" two-bedroom period property set in the backdrop of the River Wye has gone on the market for £1 million.