Provide stream-aware containers

`device_ptr` and `device_reference` use the stream provided by the CUDA system (probably the default stream, though I didn't check). That means that there is no (to me obvious) way to use them safely with the `par_nosync` execution policy or in other non-default stream contexts. They are a really convenient tool for copying single values between host and device, so it would be really helpful if we could find a way to make them stream-aware, or provide a stream-aware alternative.

This issue came up in https://github.com/rapidsai/cudf/pull/11919#issuecomment-1293124671