New £15m hospital upgrade will make lasting difference