Any bog-Standard home router will resolve hostnames on your LAN, and that’s everything you require in most cases. No ISP involvement at all.
Not every bog standard home router can do ndp proxying.
Not every bog standard home router can do ndp proxying.