The U.K.'s decision to leave the EU is unlikely to ease the funding challenges already faced by the NHS, a healthcare expert told CNBC.