We don’t have LOD support yet.
That said texture streaming is already available and working. Just enable it on the texture assets (IsStreamable property). See also https://doc.xenko.com/latest/en/manual/graphics/textures/streaming.html
You can also use scene hierarchy (child scenes). And load/unload child scene based on distance or trigger.
Look at the Top-down RPG sample and open the DynamicScene.