Following a partial right engine power loss in cruise flight, the pilot decided to make a precautionary landing at a nearby airport. While maneuvering to the airport, he noted the gear down indicator lights did not illuminate when he placed the gear handle down. After manually extending the landing gear, the pilot realized he 'didn't have enough altitude to reach [the] airfield.' A witness observed the airplane impact the surface of a lake and, subsequently, sink.