A new café with holiday lets above is set to open in York city centre.