Do I need the MSD 8920 tach adapter with a programmable ECU (e.g. Megasquirt)?

Usually not. Programmable ECUs like Megasquirt can provide a tachometer output signal directly, so the MSD 8920 is not needed.