A plan to create a new three-storey home with a roof terrace in the middle of Hereford has been passed by county planners.