Change local module require resolution to relative path

This pull request changes the require resolution for relative requires, respecting the [Amended Require Syntax and Resolution Semantics RFC](https://rfcs.luau.org/amended-require-resolution.html)