All-In-One Options

Your options are likely gonna be pretty limited and likely have to sacrifice sound quality.  Are you really that space constrained that you can’t have a separate transport and streamer or is it just for convenience?  You could get something like an Innuos Zen/Zenith and rip all your CDs into it and have most of your music available in one place with great Sense software to manage it all, but that’d still leave your SACDs that’d require a transport.  Just some thoughts, and best of luck. 

The bigger NAIM units have I believe a CD drive but I’m unsure on SACD …  I have the ATOM but Star and Nova are above it in the line. 
best to you in your search

Easier path would be an SACD player with digital inputs. Know that SACD cannot be output to external DAC unless you use something like D.BOB

Choices for SACD units with digital inputs are/

Shanling SCD3.3 SACD player - tube, r2r

Esoteric, Luxman, Accuphase

Just buy a decent streamer and connect to these units via USB  

Marantz SACD 30N looks appealing.