To find the Moonveil katana, you'll need to head into Caelid, the dead and reddish zone to the east of the Limgrave starting area. You're looking for Gael Tunnel, which is a small cave with a hole inside.