The Vgs you want to use to fully turn on a MOSFET is shown in the data sheet where the ON resistance [Vgs(on)] is specified.
For example, the data sheet for the BSS123 MOSFET you referenced shows the Rds(on) characterized at both a Vgs of 4.5V and 10V. The 10V value, of course, gives a slightly lower ON resistance but it will operate reliably as a switch with a Vgs of 5V.
If you use a P-MOSFET the load goes to the drain not the source.
The source goes to the plus supply voltage.
Incidentally the common term is ON, not Open, for a transistor that's conducting.
For example, the data sheet for the BSS123 MOSFET you referenced shows the Rds(on) characterized at both a Vgs of 4.5V and 10V. The 10V value, of course, gives a slightly lower ON resistance but it will operate reliably as a switch with a Vgs of 5V.
If you use a P-MOSFET the load goes to the drain not the source.
The source goes to the plus supply voltage.
Incidentally the common term is ON, not Open, for a transistor that's conducting.