feat(connector-besu): add option to use http or ws transport by default

Right now the Besu connector defaults to using the Web3 & Viem WebSocket transports. If your environment forbids you from using the WS transport, you have no way of telling the connector to fall back to HTTP even though internally we do have the HTTP transport instantiated and used as well.

Depends on #3844 