The screen position node (in material) would probably be a good starting point. That will sort of “project” the texture from the camera. Then you would have to figure out the camera rotation relative to the object, maybe with the CameraPositionWS and ObjectPositionWS, and som math 