While I don't have one, it looks like one of the simplest and easiest to use one-box solutions is a Brennan CD ripper. It includes a hard drive for file storage and looks up the CDs metadata for tag info. While intended as its own player, you could copy the ripped files to whatever other device you are using for local streaming.
Ripping CDs
I would like to be able to rip CDs. My streamer, Cambridge CXNv2 doesn’t have that capacity. although it can store CDs. What do I need to rip CDs?